hi, I frequently have this error un my WSS logs. Is there a patch ? Regards. Erwan WSS 3.0 French SP2 version 12.0.0.6421 Log : Une exception SQL inconnue 156 s'est produite. Des informations supplémentaires sur l'erreur provenant de SQL Server sont décrites ci-dessous. Syntaxe incorrecte vers le mot clé 'AND'. Pour plus d'informations, consultez le centre Aide et support à l'adresse http://go.microsoft.com/fwlink/events.asp. 10/12/2010 16:11:11.45 w3wp.exe (0x1418) 0x0840 Windows SharePoint Services Database 880i High System.Data.SqlClient.SqlException: Syntaxe incorrecte vers le mot clé 'AND'. à System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) à System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) à System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) à System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) à System.Data.SqlClient.SqlDataReader.ConsumeMetaData() à System.Data.SqlClient.SqlDataReader.get_MetaData() à System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOpt... 10/12/2010 16:11:11.45* w3wp.exe (0x1418) 0x0840 Windows SharePoint Services Database 880i High ...ionsString) à System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) à System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) à System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) à System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) à System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) à Microsoft.SharePoint.Utilities.SqlSession.ExecuteReader(SqlCommand command, CommandBehavior behavior) 10/12/2010 16:11:11.45 w3wp.exe (0x1418) 0x0840 Windows SharePoint Services Database 880j High SqlError: 'Syntaxe incorrecte vers le mot clé 'AND'.' Source: '.Net SqlClient Data Provider' Number: 156 State: 1 Class: 15 Procedure: '' LineNumber: 1 Server: 'SHPPRD' 10/12/2010 16:11:11.45 w3wp.exe (0x1418) 0x0840 Windows SharePoint Services Database 5586 Critical Unknown SQL Exception 156 occured. Additional error information from SQL Server is included below. Syntaxe incorrecte vers le mot clé 'AND'. 10/12/2010 16:11:11.45 w3wp.exe (0x1418) 0x0840 Windows SharePoint Services Database 880k High à Microsoft.SharePoint.SPSqlClient.ExecuteQuery(Boolean& bSucceed) à Microsoft.SharePoint.Library.SPRequestInternalClass.RenderViewAsHtml(String bstrUrl, String bstrListName, String bstrViewID, String bstrViewXml, String bstrQualifier, ISPDataCallback pDataCallback, Boolean& pbSharedList) à Microsoft.SharePoint.Library.SPRequest.RenderViewAsHtml(String bstrUrl, String bstrListName, String bstrViewID, String bstrViewXml, String bstrQualifier, ISPDataCallback pDataCallback, Boolean& pbSharedList) à Microsoft.SharePoint.WebPartPages.ListViewWebPart.RenderView() à Microsoft.SharePoint.WebPartPages.ListViewWebPart.InvokeCallbackEvent(String eventArgument) à Microsoft.SharePoint.WebPartPages.ListViewWebPart.GetCallbackResult() à System.Web.UI.Page.RenderCallback() ... 10/12/2010 16:11:11.45* w3wp.exe (0x1418) 0x0840 Windows SharePoint Services Database 880k High ...à System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) à System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) à System.Web.UI.Page.ProcessRequest() à System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context) à System.Web.UI.Page.ProcessRequest(HttpContext context) à ASP.VIEWPAGE_ASPX__871600499.ProcessRequest(HttpContext context) à System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() à System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) à System.Web.HttpApplication.ApplicationStepManager.ResumeSteps(Exception error) à System.Web.HttpAppl... 10/12/2010 16:11:11.45* w3wp.exe (0x1418) 0x0840 Windows SharePoint Services Database 880k High ...ication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData) à System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) à System.Web.HttpRuntime.ProcessRequestNoDemand(HttpWorkerRequest wr) à System.Web.Hosting.ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType) 10/12/2010 16:11:11.45 w3wp.exe (0x1418) 0x0840 Windows SharePoint Services Database 880l High ConnectionString: 'Data Source=SHPPRD;Initial Catalog=WSS_Content_DRSiD_Brest_PRD;Integrated Security=True;Enlist=False;Connect Timeout=15' ConnectionState: Closed ConnectionTimeout: 15 10/12/2010 16:11:11.45 w3wp.exe (0x1418) 0x0840 Windows SharePoint Services Database 880m High SqlCommand: ' SELECT TOP 101 t1.[Type] AS c0,UserData.[tp_ContentTypeId],UserData.[ntext2],t1.[DirName] AS c4,UserData.[nvarchar4],UserData.[tp_Created],CASE WHEN DATALENGTH(t1.DirName) = 0 THEN t1.LeafName WHEN DATALENGTH(t1.LeafName) = 0 THEN t1.DirName ELSE t1.DirName + N'/' + t1.LeafName END AS c1,UserData.[tp_ModerationStatus],UserData.[tp_Level],UserData.[nvarchar1],UserData.[tp_HasCopyDestinations],UserData.[nvarchar6],UserData.[tp_HasAttachment],t1.[TimeCreated] AS c3,UserData.[nvarchar2],UserData.[tp_ContentType],UserData.[nvarchar7],t1.[ScopeId] AS c5,t1.[LeafName] AS c2,UserData.[tp_UIVersion],UserData.[nvarchar3],UserData.[nvarchar8],UserData.[float1],UserData.[tp_ID],UserData.[tp_CopySource],UserData.[nvarchar5],UserData.[ntext3] FROM UserData INNER MERGE JOIN Docs AS t1 ... 10/12/2010 16:11:11.45* w3wp.exe (0x1418) 0x0840 Windows SharePoint Services Database 880m High ...WITH(NOLOCK) ON ( 1 = 1 AND UserData.[tp_RowOrdinal] = 0 AND t1.SiteId = UserData.tp_SiteId AND t1.SiteId = @L2 AND t1.DirName = UserData.tp_DirName AND t1.LeafName = UserData.tp_LeafName AND t1.Level = UserData.tp_Level AND t1.IsCurrentVersion = 1 AND (1 = 1)) WHERE (UserData.tp_IsCurrent = 1) AND UserData.tp_SiteId=@L2 AND (UserData.tp_DirName=@DN) AND UserData.tp_RowOrdinal=0 AND ((UserData.[nvarchar1] COLLATE French_CI_AS=@L3TXP) AND (UserData.[nvarchar7] COLLATE French_CI_AS = N'Actif') AND t1.SiteId=@L2 AND (t1.DirName=@DN)) AND (UserData.[nvarchar5] COLLATE French_CI_AS = CAST(N'Partiellement conforme' AND UserData.[nvarchar6] COLLATE French_CI_AS = N'ZMT') ORDER BY UserData.[nvarchar5] COLLATE French_CI_AS Asc,UserData.[nvarchar6] COLLATE French_CI_AS Asc,UserData.[nvarchar1]... 10/12/2010 16:11:11.45* w3wp.exe (0x1418) 0x0840 Windows SharePoint Services Database 880m High ... COLLATE French_CI_AS Asc,UserData.[tp_ID] Asc OPTION (FORCE ORDER) ' CommandType: Text CommandTimeout: 0 Parameter: '@L0' Type: UniqueIdentifier Size: 0 Direction: Input Value: '00000000-0000-0000-0000-000000000000' Parameter: '@L2' Type: UniqueIdentifier Size: 0 Direction: Input Value: '32dae981-ede4-46aa-8b05-c565b1ed28d6' Parameter: '@L3TXP' Type: NVarChar Size: 255 Direction: Input Value: '09-13-293' Parameter: '@DN' Type: NVarChar Size: 260 Direction: Input Value: 'chorus/Lists/marches'

I don't speak french. But if I had to guess it looks like your database is not of the same collation as your input. Therefore, some special character is breaking the sql statement. Maybe when you installed it didn' setup the right collation?Brian Bedard, MCTS - pioneeringsharepoint.blogspot.com - Twitter:@tigertoy